package com.ftwj.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ftwj.entity.SysUser;
import com.ftwj.vo.UserVO;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.data.repository.query.Param;

import java.util.List;

@Mapper
public interface SysUserMapper extends BaseMapper<SysUser> {
    // 自定义SQL查询方法
    List<UserVO> queryUsersByConditions(@Param("userName") String userName, @Param("sex") String sex, @Param("phoneNumber") String phoneNumber);
    UserVO getUserById(@Param("id") String id);
    List<SysUser> selectByPhone(String phoneNumber);
}